Attaching Slicers

Attaching and Detaching Slicers

Once they have been created, you can attach slicers to (and detach them from) data within a Tabulation. This enables the data to be filtered to only show values relevant to the selected slicer.

For example, if we have a slicer called 'Date year', created from data representing Years from the selected model, then you can use this slicer to filter the displayed data by year.

Attaching a Slicer

You attach a slicer to displayed data as follows:

  1. Select the cells to which the slicer is to be attached. You can either select a single cell, or multiple cells.
  2. Click Attach/Detach Slicers in the Query Tools section of the Advanced Setting ribbon:

  3. The Attach/Detach Slicers dialog is displayed:

    4. This dialog lists all the slicers that have been created for the Tabulation.

  4. Click in the checkbox next to the slicer name.
  5. Click Apply. The selected slicer is attached to the selected cells and appears above the worksheet.

Detaching a Slicer

You detach a slicer from the displayed data as follows:

  1. Select the cells from which the slicer is to be detached.

    2. Note: If the slicer is attached to multiple cells, you can choose to detach the slicer from all (or only some) of the cells by appropriate selections.

  2. Click Attach/Detach Slicers in the Query Tools section of the Advanced Setting ribbon, as shown above.
  3. The Attach/Detach Slicers dialog is displayed:

    4. This dialog lists all the slicers that have been created for the Tabulation. The checkbox next to a slicer name indicates that it is attached to the selected cell(s).

  4. Click in the checkbox next to the slicer name to deselect it.
  5. Click Apply. The selected slicer is detached from the selected cells. It may still be displayed above the worksheet if it is attached to other cells.

Other topics